﻿<?xml version="1.0" encoding="utf-8" ?>
<AdoNetDataAccess connection="$SyrinxDBConnection$" formatter="bizobj of TreeNode">
	<Sql>
		SELECT
		id, objectId, parentId, parentHostId, rootId,
		name, keyName depth, treeName
		FROM
		ObjectTreeNodes as t
		LEFT OUTER JOIN ObjectTreeCounts as c on c.objectId = t.objectId
		
		WHERE
		keyName=@keyName and treeName=@treeName
	</Sql>
	<Param name="keyName" type="String"/>
	<Param name="treeName" type="String"/>
</AdoNetDataAccess>